{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "shtSrc= pd.read_excel(\"Fusion.xlsx\", sheet_name = 0,skiprows=3,skipfooter=1)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID</th>\n",
       "      <th>Summary</th>\n",
       "      <th>Issue Type</th>\n",
       "      <th>Key</th>\n",
       "      <th>Competence Area</th>\n",
       "      <th>Start FB</th>\n",
       "      <th>End FB</th>\n",
       "      <th>FB Committed Status</th>\n",
       "      <th>Σ Original Estimate</th>\n",
       "      <th>Σ Logged Effort</th>\n",
       "      <th>Σ Remaining Estimate</th>\n",
       "      <th>Assignee</th>\n",
       "      <th>Reporter</th>\n",
       "      <th>Planned System Release</th>\n",
       "      <th>Parent Link</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>5GC000704-G-a1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-a1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318340</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1906</td>\n",
       "      <td>1906</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1080000</td>\n",
       "      <td>0h</td>\n",
       "      <td>1080000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183345GC000704-G-a : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>5GC000704-G-b1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-b1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318341</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907</td>\n",
       "      <td>1907</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000</td>\n",
       "      <td>0h</td>\n",
       "      <td>2160000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183355GC000704-G-b : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>5GC000704-G-c1</td>\n",
       "      <td>5GC000704</td>\n",
       "      <td>5GC000704-G-c1 : Handling of concurrency betwe...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-318342</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1907</td>\n",
       "      <td>1908</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2160000</td>\n",
       "      <td>0h</td>\n",
       "      <td>2160000</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-3183365GC000704-G-c : Handling of concurre...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5GC000733-F-A-a4</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-A-a4: Idle paging - Updation of TA...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-278811</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903</td>\n",
       "      <td>1903</td>\n",
       "      <td>Committed</td>\n",
       "      <td>108000</td>\n",
       "      <td>30h</td>\n",
       "      <td>0</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Kumar, Ajay B. (Nokia - IN/Bangalore)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-2788075GC000733-F: Idle paging</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5GC000733-F-a16</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...</td>\n",
       "      <td>Competence Area</td>\n",
       "      <td>FPB-292620</td>\n",
       "      <td>ECE C-Plane NRT</td>\n",
       "      <td>1903</td>\n",
       "      <td>1903</td>\n",
       "      <td>Committed</td>\n",
       "      <td>144000</td>\n",
       "      <td>40h</td>\n",
       "      <td>0</td>\n",
       "      <td>Du, Jianjun B. (NSB - CN/Shanghai)</td>\n",
       "      <td>Dsouza, Allan (Nokia - IN/Bangalore)</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>FPB-2788075GC000733-F: Idle paging</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Item ID Feature ID  \\\n",
       "0    5GC000704-G-a1  5GC000704   \n",
       "1    5GC000704-G-b1  5GC000704   \n",
       "2    5GC000704-G-c1  5GC000704   \n",
       "3  5GC000733-F-A-a4  5GC000733   \n",
       "4   5GC000733-F-a16  5GC000733   \n",
       "\n",
       "                                             Summary       Issue Type  \\\n",
       "0  5GC000704-G-a1 : Handling of concurrency betwe...  Competence Area   \n",
       "1  5GC000704-G-b1 : Handling of concurrency betwe...  Competence Area   \n",
       "2  5GC000704-G-c1 : Handling of concurrency betwe...  Competence Area   \n",
       "3  5GC000733-F-A-a4: Idle paging - Updation of TA...  Competence Area   \n",
       "4  5GC000733-F-a16: Updation TAC to 5G-CP-CELL in...  Competence Area   \n",
       "\n",
       "          Key  Competence Area  Start FB  End FB FB Committed Status  \\\n",
       "0  FPB-318340  ECE C-Plane NRT      1906    1906                 NaN   \n",
       "1  FPB-318341  ECE C-Plane NRT      1907    1907                 NaN   \n",
       "2  FPB-318342  ECE C-Plane NRT      1907    1908                 NaN   \n",
       "3  FPB-278811  ECE C-Plane NRT      1903    1903           Committed   \n",
       "4  FPB-292620  ECE C-Plane NRT      1903    1903           Committed   \n",
       "\n",
       "   Σ Original Estimate Σ Logged Effort  Σ Remaining Estimate  \\\n",
       "0              1080000              0h               1080000   \n",
       "1              2160000              0h               2160000   \n",
       "2              2160000              0h               2160000   \n",
       "3               108000             30h                     0   \n",
       "4               144000             40h                     0   \n",
       "\n",
       "                             Assignee                               Reporter  \\\n",
       "0  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "1  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "2  Du, Jianjun B. (NSB - CN/Shanghai)     Du, Jianjun B. (NSB - CN/Shanghai)   \n",
       "3  Du, Jianjun B. (NSB - CN/Shanghai)  Kumar, Ajay B. (Nokia - IN/Bangalore)   \n",
       "4  Du, Jianjun B. (NSB - CN/Shanghai)   Dsouza, Allan (Nokia - IN/Bangalore)   \n",
       "\n",
       "  Planned System Release                                        Parent Link  \n",
       "0                  5G19B  FPB-3183345GC000704-G-a : Handling of concurre...  \n",
       "1                  5G19B  FPB-3183355GC000704-G-b : Handling of concurre...  \n",
       "2                  5G19B  FPB-3183365GC000704-G-c : Handling of concurre...  \n",
       "3                  5G19B                 FPB-2788075GC000733-F: Idle paging  \n",
       "4                  5G19B                 FPB-2788075GC000733-F: Idle paging  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtSrc.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Item ID</th>\n",
       "      <th>Feature ID</th>\n",
       "      <th>Planned System Release</th>\n",
       "      <th>Summary</th>\n",
       "      <th>FB Committed Status</th>\n",
       "      <th>End FB</th>\n",
       "      <th>Start FB</th>\n",
       "      <th>Σ Remaining Estimate</th>\n",
       "      <th>Σ Logged Effort</th>\n",
       "      <th>Σ Original Estimate</th>\n",
       "      <th>...</th>\n",
       "      <th>1909</th>\n",
       "      <th>1909.1</th>\n",
       "      <th>1910</th>\n",
       "      <th>1910.1</th>\n",
       "      <th>1911</th>\n",
       "      <th>1911.1</th>\n",
       "      <th>1912</th>\n",
       "      <th>1912.1</th>\n",
       "      <th>1913</th>\n",
       "      <th>1913.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>ECERD-3981</td>\n",
       "      <td>ECERD-3981</td>\n",
       "      <td>5G19A</td>\n",
       "      <td>CP-NRT_trbl_log_list.csv is missing</td>\n",
       "      <td>Plan</td>\n",
       "      <td>1904.0</td>\n",
       "      <td>1904.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>ECERD-4136</td>\n",
       "      <td>ECERD-4136</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>ECERD-4136 Uncaught/improper exception causing...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1905.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>5GC000733-Q-B-a1</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>5GC000733-Q-B-a1: Idle Paging Error Handling -...</td>\n",
       "      <td>Committed</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0h</td>\n",
       "      <td>160.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>5GC000733-Q-B-a2</td>\n",
       "      <td>5GC000733</td>\n",
       "      <td>5G19B</td>\n",
       "      <td>5GC000733-Q-B-a2: Idle Paging Error Handling - F1</td>\n",
       "      <td>Committed</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>1906.0</td>\n",
       "      <td>160.0</td>\n",
       "      <td>0h</td>\n",
       "      <td>160.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Item ID  Feature ID Planned System Release  \\\n",
       "0        ECERD-3981  ECERD-3981                  5G19A   \n",
       "1        ECERD-4136  ECERD-4136                  5G19B   \n",
       "2               NaN         NaN                    NaN   \n",
       "3  5GC000733-Q-B-a1   5GC000733                  5G19B   \n",
       "4  5GC000733-Q-B-a2   5GC000733                  5G19B   \n",
       "\n",
       "                                             Summary FB Committed Status  \\\n",
       "0                CP-NRT_trbl_log_list.csv is missing                Plan   \n",
       "1  ECERD-4136 Uncaught/improper exception causing...                 NaN   \n",
       "2                                                NaN                 NaN   \n",
       "3  5GC000733-Q-B-a1: Idle Paging Error Handling -...           Committed   \n",
       "4  5GC000733-Q-B-a2: Idle Paging Error Handling - F1           Committed   \n",
       "\n",
       "   End FB  Start FB  Σ Remaining Estimate Σ Logged Effort  \\\n",
       "0  1904.0    1904.0                   NaN             NaN   \n",
       "1  1905.0       NaN                   NaN             NaN   \n",
       "2     NaN       NaN                   NaN             NaN   \n",
       "3  1906.0    1906.0                 160.0              0h   \n",
       "4  1906.0    1906.0                 160.0              0h   \n",
       "\n",
       "   Σ Original Estimate  ... 1909 1909.1  1910 1910.1 1911 1911.1 1912 1912.1  \\\n",
       "0                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "1                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "2                  NaN  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "3                160.0  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "4                160.0  ...  NaN    NaN   NaN    NaN  NaN    NaN  NaN    NaN   \n",
       "\n",
       "  1913  1913.1  \n",
       "0  NaN     NaN  \n",
       "1  NaN     NaN  \n",
       "2  NaN     NaN  \n",
       "3  NaN     NaN  \n",
       "4  NaN     NaN  \n",
       "\n",
       "[5 rows x 48 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shtTgt = pd.read_excel(\"5G_Feature_Planning.xlsx\",sheet_name=\"Feature Plan\", skiprows = 1)\n",
    "shtTgt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
